Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Export Transformer

The transformer process "transforms" the information in the staging table into an ASCII file that can be imported into Deltek Costpoint 6x or higher.

The transformation process is executed at the end of the export step.

In order for the transformation process to occur, you must place a file named ExportExpense.properties in the directory specified in the Export Location field on the Miscellaneous tab of the Configure General Settings screen. This file contains information for the type of transformer that will be executed.

The valid values for transformation are COSTPOINT7X, COSTPOINT6X. There should be at least one line in the ExportExpense.properties file. The format of the line is as follows:

  • EXPORT=COSTPOINT7X
  • EXPORT=COSTPOINT6X

    In addition to specifying the layout of the transformed ASCII file, you can space out one or more of the User-Defined Table (UDT) fields by placing the following parameter in the properties file: EXPORT_UDTXX=N.

    For example, if you want UDT03 to be removed from ASCII file so the destination system can provide a default, use "EXPORT_UDT03=N."

Note: The program creates the ASCII file in the Export directory. The name of the file is "<Batch ID>.exp." When the transformation is completed, the export staging tables are cleared for the selected batch ID.
Attention: Review the "Transformed Export ASCII Layouts" chapter in the Deltek Time & Expense Technical Guide for information on the ASCII file layouts.